package pw_coding

import (
	"database/sql"
	"time"
)

// mysql table信息
type TABLES struct {
	TABLE_CATALOG   string        `xorm:"varchar(512) notnull 'TABLE_CATALOG'"`
	TABLE_SCHEMA    string        `xorm:"varchar(64) notnull 'TABLE_SCHEMA'"`
	TABLE_NAME      string        `xorm:"varchar(64) notnull 'TABLE_NAME'"`
	TABLE_TYPE      string        `xorm:"varchar(64) notnull 'TABLE_TYPE'"`
	ENGINE          string        `xorm:"varchar(64) 'ENGINE'"`
	VERSION         sql.NullInt64 `xorm:"bigint 'VERSION'"`
	ROW_FORMAT      string        `xorm:"varchar(10) 'ROW_FORMAT'"`
	TABLE_ROWS      sql.NullInt64 `xorm:"bigint 'TABLE_ROWS'"`
	AVG_ROW_LENGTH  sql.NullInt64 `xorm:"bigint 'AVG_ROW_LENGTH'"`
	DATA_LENGTH     sql.NullInt64 `xorm:"bigint 'DATA_LENGTH'"`
	MAX_DATA_LENGTH sql.NullInt64 `xorm:"bigint 'MAX_DATA_LENGTH'"`
	INDEX_LENGTH    sql.NullInt64 `xorm:"bigint 'INDEX_LENGTH'"`
	DATA_FREE       sql.NullInt64 `xorm:"bigint 'DATA_FREE'"`
	AUTO_INCREMENT  sql.NullInt64 `xorm:"bigint 'AUTO_INCREMENT'"`
	CREATE_TIME     time.Time     `xorm:"datetime 'CREATE_TIME'"`
	UPDATE_TIME     time.Time     `xorm:"datetime 'UPDATE_TIME'"`
	CHECK_TIME      time.Time     `xorm:"datetime 'CHECK_TIME'"`
	TABLE_COLLATION string        `xorm:"varchar(32) 'TABLE_COLLATION'"`
	CHECKSUM        sql.NullInt64 `xorm:"bigint 'CHECKSUM'"`
	CREATE_OPTIONS  string        `xorm:"varchar(255) 'CREATE_OPTIONS'"`
	TABLE_COMMENT   string        `xorm:"varchar(2048) 'TABLE_COMMENT'"`
}
